How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server)
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server) The firewall and network settings looks fine. However we are…
Sql server Metrics : is 100% CPU percentage is a blocker for all DB operations?
HI All We have observed a case in our database where the CPU perncetage is 100% for quite some time but my application are still able to hit & operate over DB, is 100% CPU usage isnt a blocker for DB operations ?? I see 2 CPU metrics 1) CPU…
How do I create a new Server
On my initial creation of our Azure SQL account I was asked to create a server, so I started with a development server housing several databases, but now I'd like to create a test/staging and production server so that I can migrate updates to databases…
When I installed Azure Data Studio connected to SQL version 2022 and wanted to restore advanturework 2022 for practice, there was no Restore data section when right-clicking on the Database, only Filter and Refresh sections. How to fix this error? SQL Se
When I installed Azure Data Studio connected to SQL version 2022 and wanted to restore advanturework 2022 for practice, there was no Restore data section when right-clicking on the Database, only Filter and Refresh sections. How to fix this error? SQL…
Copy activity throwing an error, when a auto incremented column is there on the Sink side
Hello Team, I am trying to copy data from Amazon S3 to Azure SQL database. On Azure SQL side I have set an autoincrement column(Row_Index) in a table, however the copy activity throws an error that "Column 'Row_Index' does not allow…
Help with an architecture design
Hello, We have a European customer who wants their data to be located in Europe. We also want to upgrade our current on-prem SQL Server to an Azure Managed Instance (Azure SQL Database is out of scope). Our main database is located in the US, and we need…
Is it Azure Managed Instance storage having size limit to upload the backup file?
Hello, I am trying to upload the .bak files from my on-prem Sql Server database backup but it's not letting me to load it. I tried with smaller Database and that works but trying to even less then 300 MB database size but not working. Is it Database…
How to fix "Failure happened on 'Source' side A task was canceled" error
Data load from Salesforce object with 1million records fails with the below error in Azure Data Factory: Failure happened on 'Source' side. 'Type=System.Threading.Tasks.TaskCanceledException,Message=A task was canceled.,Source=mscorlib,' The data load…
Creating new linked services returns SqlFailedToConnect
I'd like to start by first stating that this is a continuation of my efforts to connect an Azure SQL DB to Data Factory via the Linked services. Creating new linked services returns InvalidCredentialReference My new error is below in the azure portal in…
Azure Data Sync is taking longer than Expected for data sync.
Hi Team, I am doing POC for Bi-Directional data Sync using Azure Data Sync Approach. I am facing following Issues - The minimum time between each sync across databases is 5 seconds. Can this be minimized further. Assume we are bi-directionally…
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
bit null ,0
Hey Team, have column1 datatype (bit,null) so it only takes values like 0 and 1 but i want true , false as well...how to get that in same datatype or in different one
How do I copy all columns properties with copy activity in data factory
Hi, I'm copying data from one DB to another DB with copy activity and auto create table. I noticed that when the table is creating on the target side it is creating with the column size and type but all the other properties are lost, for example…
From Synapse notebook, trouble connecting to Azure SQL using system managed identity
I can create a Linked Service to my Database using my Synapse system-managed identity. This works fine, and the "test connection" shows success. But for the life of me, I can't figure out how to do it in a Python notebook. Here is the…
Incremental ETL From Mysql to Azure
Hello Professionals, I am having a totally new experience with AZURE as I have never worked on it , but due to some conditions I have to use AZURE , I am having some issues In making a incremental Data Flow that should extract data from 4 MySQL Server…
Parameters for switch between linked services
I have a pipeline in Azure Synapse which has multiple dataflows and I have 2 linked service how can I use the pipeline parameters to switch between linked services without changing the linked services in each data manually.
Connection failed
Spark job failed: { "text/plain":…
Using Entra ID Auth Only in ADF + Azure SSIS IR solution
Hi, We're currently working on complying with Microsoft cloud security benchmark in our tenant and ran into an issue with our Azure Data Factory service. To comply, we need to have only Entra ID Auth on our Azure SQL DBs. We're using Azure Data Factory…
403 Forbidden Error When Running SSRS Reports from Azure Web App within VNet
Hello everyone, I’m facing an issue with accessing SSRS reports hosted on a virtual machine from an Azure Web App with the database on a separate managed instance and the SSRS on a VM with access done via URL. Here’s the situation: The reports execute…
Should I update statistics immediately after migrating to Azure SQL Server Managed Instance
I am migrating my 4TB database of Microsoft SQL Server 2016 2 node AG cluster from on-premises to Azure SQL Managed Instance. I am using Azure Data Studio to migrate through full backup and continuously applying log backup. This backup will be ongoing…